package dao;

import entity.Student;
import org.apache.ibatis.annotations.Param;


import java.util.Date;
import java.util.List;

public interface StudentMapper {
    public List<Student> findALL();
    public int add(Student s);
    public int update(Student s);
    public int del(long id);
    public Student get(long id);
    public List<Student> fenye(@Param("ye") int ye, @Param("hang") int hang);
    public List<Student> mohu(@Param("sname") String sname, @Param("qq") String q, @Param("telephone") String sjh, @Param("enterStart") Date enterStart, @Param("enterEnd") Date enterEnd);
    //模糊查询 符合条件总数
    public int mohuzongshu(@Param("sname") String sname, @Param("qq") String q, @Param("telephone") String sjh, @Param("enterStart") Date enterStart, @Param("enterEnd") Date enterEnd);
}
